package com.zany.util.file;

public class ExeclHeader {
	
	public static final String EXECL_HEADER_COSTQUERY = "缴费清单(单笔)";
	public static final String EXECL_HEADER_UPDATEMONEY = "修改金额清单";
	public static final String EXECL_HEADER_REPAIRQUERY = "维修记录清单";
	public static final String EXECL_HEADER_LOGQUERY = "日志清单"; 
	public static final String EXECL_HEADER_PROJECTQUERY = "维修项目清单";
	public static final String EXECL_HEADER_ALARMQUERY = "预警用户清单";
	public static final String EXECL_HEADER_BALANCEQUERY = "账户余额查询清单";
	public static final String EXECL_HEADER_FUNDQUERY = "收支查询清单";
	public static final String EXECL_HEADER_RATEQUERY = "计息查询清单";
	public static final String EXECL_HEADER_PURPOSEQUERY = "房屋用途查询";
	public static final String EXECL_HEADER_BATCHQUERY = "批量缴费清单";
	public static final String EXECL_HEADER_SHAREMONEY = "利息分摊";
	public static final String EXECL_HEADER_INTERESTPROJECT = "维修项目";
	public static final String EXECL_HEADER_HOUSEMAP = "房屋地图";
	public static final String EXECL_HEADER_FUNDRETURN = "资金返还";
	public static final String EXECL_HEADER_AREA = "小区清单";
	public static final String EXECL_HEADER_DOOR = "户清单";
	
	public static final String[][] EXECL_LS_COSTQUERY = { 
	    { "小区", "areaName" }, 
	    { "栋", "groupId" }, 
	    { "单元", "unitId" },
	    { "户", "doorId" },
	    { "房屋编号", "houseId" },
	    { "姓名", "userName" },
	    { "证件号码", "papersCode" },
	    { "缴费流水号", "bankSerial" },
	    { "缴费金额（元）", "costMoney" },
	    { "日期", "costDate" },
	    { "存款状态", "costSts" },
	    { "备注", "houseMoney" },
	    { "面积", "space" },
	    { "地址电话", "doorAddr" },
	    { "预缴金额", "moneyBudget" }
	};
	
	public static final String[][] EXECL_LS_UPDATEMONEY = { 
	    { "小区", "areaName" }, 
	    { "栋", "groupId" }, 
	    { "单元", "unitId" },
	    { "户", "doorId" },
	    { "房屋编号", "houseId" },
	    { "原预缴金额", "moneyBudget" },
		{ "修改预缴资金", "moneyBudgetUpdate" },
		{ "原资金余额", "balance" },
		{ "修改资金余额", "balanceUpdate" },
		{ "原计息前余额", "balanceTemp" },
		{ "修改计息前余额", "balanceTempUpdate" },
		{ "原利息合计", "rateTotal" },
		{ "修改利息合计", "rateTotalUpdate" },
		{ "原缴费金额", "moneyOri" },
		{ "修改缴费金额", "moneyOriUpdate" },
		{ "原缴费时间", "moneyDate" },	
		{ "修改缴费时间", "moneyDateUpdate" },	
		{ "修改时间", "updateDate" },	
		{ "修改人", "creater" },	
		{ "备注", "remark" }
	};
	
	public static final String[][] EXECL_LS_DOORQUERY = { 
	    { "小区", "areaName" }, 
	    { "栋", "groupId" }, 
	    { "单元", "unitId" },
	    { "户", "doorId" },
	    { "房屋编号", "houseId" },
	    { "姓名", "userName" },
	    { "证件号码", "papersCode" },
	    { "预缴资金", "moneyBudget" },
	    { "余额", "balance" },
	    { "缴费时间", "moneyDate" },
	    { "发票号码", "invoiceNo" }
	};
	public static final String[][] EXECL_LS_BATCHQUERY = { 
	    { "小区", "areaName" }, 
	    { "开发商", "estateName" }, 
	    { "金额（元）", "costMoney" },    
	    { "批量状态", "batchSts" },
	    { "建批日期", "batchDate" },
	    { "创建人", "creater" }
	};
	
	public static final String[][] EXECL_REPAIRQUERY = { 
	    { "小区", "areaId" }, 
	    { "栋", "groupId" }, 
	    { "单元", "unitId"},
	    { "户", "doorId" },
	    { "户主", "userName"},
	    { "证件号码", "papersCode" },
	    { "维修项目", "projectName" },
	    { "分摊金额（元）", "repairMoney" },
	    { "不足金额（元）", "noMoney" },
	    { "面积（㎡）", "space" },
	    { "日期", "repairDate" }
	};
	
	public static final String[][] EXECL_PROJECTQUERY = { 
	    { "小区", "areaId" }, 
	    { "栋", "groupId" }, 
	    { "维修项目名称", "projectName" },
	    { "维修项目金额（元）", "projectMoney" },
	    { "日期", "createDate" },
	    { "备注", "remark" }
	};
	
	public static final String[][] EXECL_ALARMQUERY = { 
	    { "小区", "areaName" }, 
	    { "栋", "groupId" },
	    { "单元", "unitId" },
	    { "户", "doorId" },
	    { "面积（㎡）", "space" },
	    { "账户余额（元）", "balance" },
	    { "姓名", "userName" }
	};
	
	public static final String[][] EXECL_BALANCEQUERY = { 
	    { "小区", "areaName" }, 
	    { "栋", "groupId" },
	    { "单元", "unitId" },
	    { "户", "doorId" },
	    { "账户余额（元）", "balance" },
	    { "计息前余额（元）", "balanceTemp" },
	    { "姓名", "userName" },
	    { "面积（㎡）", "space" },
	    { "用途", "purpose" }
	};
	
	public static final String[][] EXECL_FUNDQUERY = { 
	    { "小区", "areaName" }, 
	    { "缴费金额（元）", "costMoney" },
	    { "缴费户数", "costCount" },
	    { "维修金额（元）", "repairMoney" },
	    { "维修户数", "repairCount" }
	};
	
	public static final String[][] EXECL_LOGQUERY = { 
	    { "修改者", "creater" }, 
	    { "修改时间", "createDate" },
	    { "功能名称", "resourceName" },
	    { "修改前数据", "dataBefore" },
	    { "修改后数据", "dataAfter" },
	    { "户", "doorId" }
	};
	
	public static final String[][] EXECL_RATEQUERY = { 
	    { "计息日", "rateDate" }, 
	    { "本息合计（元）", "balanceSum" },
	    { "本金合计（元）", "balanceTempSum" },
	    { "利息合计（元）", "rate" },
	    { "小区名称", "areaName" },
	    { "栋", "groupId" }
	};
	
	public static final String[][] EXECL_PURPOSEQUERY = { 
		{ "小区", "areaName" }, 
	    { "栋", "groupId" },
	    { "单元", "unitId" },
	    { "户", "doorId" },
	    { "姓名", "userName" },
	    { "面积（㎡）", "space" },
	    { "预缴基金（元）", "moneyBudget" },
	    { "账户余额（元）", "balance" }
	};
	
	public static final String[][] EXECL_SHAREMONEY = { 
		{ "小区", "areaName" }, 
	    { "栋", "groupId" },
	    { "分摊时间", "shareDate" },
	    { "分摊金额", "shareMoney" },
	    { "总金额", "shareTotal" }
	};
	
	public static final String[][] EXECL_INTERESTPROJECT = { 
		{ "小区", "areaName" }, 
	    { "栋", "groupId" },
	    { "维修项目名称", "projectName" },
	    { "维修项目金额", "projectMoney" },
	    { "日期", "projectDate" },
	    { "执行状态", "sts" }
	};
	
	public static final String[][] EXECL_FUNDRETURN = { 
		{ "小区", "areaName" }, 
	    { "栋", "groupId" },
	    { "单元", "unitId" },
	    { "户", "doorId" },
	    { "房屋编号", "houseId" },
	    { "返回金额", "returnMoney" },
	    { "操作员", "returner" },
	    { "返回日期", "returnDate" }
	};
	
	public static final String[][] EXECL_AREAQUERY = { 
		{"小区名称","areaName"},		
		{"创建时间","createDate"},	
		{"开发商","estateId"},
		{"物业公司","tenementId"},
		{"业主委员会","committeeId"},
		{"质保金缴交情况","marginSts"},
		{"验收楼栋数","groupNumber"},
		{"验收建筑面积","checkSpace"},
		{"物业用房面积","tenementSpace"},
		{"物业用房位置","tenementAddr"},
		{"物业用房是否备案","tenementSts"},
		{"屋面防水质保期","preventWater"},
		{"道路质保期","preventLoad"},
		{"物业验收时间","tenementCheck"},
		{"竣工报告时间","completionDate"},
		{"所在街道社区","inRoad"},
		{"楼房数量","checkGroupNumber"},
		{"地址","areaAddr"},
		{"备注","remark"},
		{"质量保证金","fileName1"},
		{"物业用房协议书","fileName2"},
		{"开发公司与物业公司交接","fileName3"},
		{"备案表","fileName4"}
	};
}
